Find member has special feature to load criteria from file:
· Right click selected level (our case Customer)
· Select Find members … from menu
Dialog will appear:
§ Select button Import
· Select Select file button
· Select appropriate version of Excel
· Navigate to file where your criteria have been saved
· Select Open button
· Select Import
NOTE: Criteria saved in MS Excel file MUST be saved in first (A)
column
· Select OK
All of your saved criteria are loaded. Sign for OR logical function is “||” (double pipe).
· Select OK
Now you can reduce your selection or select all of them.
After that select
· Select OK
Selected members will be visible inside cube browser.
To add all of them to the row or column area:
· Right click one of them
· Select Add all members to
· Select one of areas